﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE sp_InsertRawEvent
	-- Add the parameters for the stored procedure here
	@MeterNumber nvarchar,
	@MeterVendorID nvarchar,
	@MeterHeadEndID nvarchar,
	@TimeStamp datetime,
	@EventType nvarchar,
	@Reading float,
	@Temp float
AS
BEGIN
	INSERT INTO [AMIDataStore].[dbo].[RawEvents]
           ([MeterNumber]
           ,[MeterVendorID]
           ,[MeterHeadEndID]
           ,[TimeStamp]
           ,[EventType]
           ,[Reading]
           ,[Temp])
     VALUES
           (
           @MeterNumber,
           @MeterVendorID,
           @MeterHeadEndID,
           @TimeStamp,
           @EventType,
           @Reading,
           @Temp
           )
END
